<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="TaskDataSet" targetNamespace="http://www.badhabit.com/XMLSchema/2008/TaskDataSet.xsd" xmlns:mstns="http://www.badhabit.com/XMLSchema/2008/TaskDataSet.xsd" xmlns="http://www.badhabit.com/XMLSchema/2008/TaskDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DataSetFile="TaskDataSet.Dataset.Designer.cs" DataSetProject="FactoryCore" DefaultConnectionIndex="2" FunctionsComponentName="TaskTailQueryAdapter" GeneratorFunctionsComponentClassName="TaskTailQueryAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="ExcludeSchema" UserFunctionsComponentName="TaskTailQueryAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="FactoryConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="FactoryConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.BadHabit.Factory.Data.Properties.Settings.GlobalReference.Default.FactoryConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="FactoryConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="FactoryConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.BadHabit.Factory.Data.Properties.Settings.GlobalReference.Default.FactoryConnectionString1" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="FactoryConnectionStringDEV" IsAppSettingsProperty="true" Modifier="FamilyAndAssembly" Name="FactoryConnectionStringDEV (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.BadHabit.Factory.Data.Properties.Settings.GlobalReference.Default.FactoryConnectionStringDEV" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TaskTableAdapter" GeneratorDataComponentClassName="TaskTableAdapter" Name="Task" UserDataComponentName="TaskTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.Task" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [factory].[Task] WHERE (([TaskUId] = @Original_TaskUId) AND ([TaskId] = @Original_TaskId) AND ([TaskName] = @Original_TaskName) AND ((@IsNull_TaskDescription = 1 AND [TaskDescription] IS NULL) OR ([TaskDescription] = @Original_TaskDescription)) AND ([TaskType] = @Original_TaskType) AND ((@IsNull_TaskAssignee = 1 AND [TaskAssignee] IS NULL) OR ([TaskAssignee] = @Original_TaskAssignee)) AND ([TaskOwner] = @Original_TaskOwner) AND ([Status] = @Original_Status) AND ((@IsNull_Start = 1 AND [Start] IS NULL) OR ([Start] = @Original_Start)) AND ((@IsNull_PlannedStart = 1 AND [PlannedStart] IS NULL) OR ([PlannedStart] = @Original_PlannedStart)) AND ((@IsNull_Finish = 1 AND [Finish] IS NULL) OR ([Finish] = @Original_Finish)) AND ([CreateDate] = @Original_CreateDate) AND ([Priority] = @Original_Priority) AND ((@IsNull_Duration = 1 AND [Duration] IS NULL) OR ([Duration] = @Original_Duration)) AND ((@IsNull_ActualEffort = 1 AND [ActualEffort] IS NULL) OR ([ActualEffort] = @Original_ActualEffort)) AND ((@IsNull_PlannedEffort = 1 AND [PlannedEffort] IS NULL) OR ([PlannedEffort] = @Original_PlannedEffort)) AND ((@IsNull_PercentComplete = 1 AND [PercentComplete] IS NULL) OR ([PercentComplete] = @Original_PercentComplete)) AND ([ProjectUId] = @Original_ProjectUId) AND ([BacklogItemNumber] = @Original_BacklogItemNumber) AND ([Payable] = @Original_Payable) AND ((@IsNull_PlannedFinish = 1 AND [PlannedFinish] IS NULL) OR ([PlannedFinish] = @Original_PlannedFinish)) AND ([UnitName] = @Original_UnitName) AND ([BacklogItemUId] = @Original_BacklogItemUId) AND ((@IsNull_SprintUId = 1 AND [SprintUId] IS NULL) OR ([SprintUId] = @Original_SprintUId)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TaskUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TaskUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TaskId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaskId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TaskName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TaskDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaskDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TaskDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_TaskType" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TaskType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TaskAssignee" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaskAssignee" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TaskAssignee" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskAssignee" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TaskOwner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskOwner" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Start" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Start" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PlannedStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlannedStart" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PlannedStart" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="PlannedStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Finish" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Finish" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Finish" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Finish" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Priority" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Duration" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Duration" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Duration" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Duration" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ActualEffort" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ActualEffort" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ActualEffort" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ActualEffort" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PlannedEffort" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlannedEffort" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_PlannedEffort" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PlannedEffort" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PercentComplete" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PercentComplete" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_PercentComplete" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PercentComplete" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_BacklogItemNumber" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="BacklogItemNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Payable" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Payable" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PlannedFinish" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlannedFinish" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PlannedFinish" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="PlannedFinish" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UnitName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UnitName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_BacklogItemUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="BacklogItemUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SprintUId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SprintUId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_SprintUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SprintUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [factory].[Task] ([TaskUId], [TaskName], [TaskDescription], [TaskType], [TaskAssignee], [TaskOwner], [Status], [Start], [PlannedStart], [Finish], [CreateDate], [Priority], [Duration], [ActualEffort], [PlannedEffort], [PercentComplete], [ProjectUId], [BacklogItemNumber], [Payable], [PlannedFinish], [UnitName], [BacklogItemUId], [SprintUId]) VALUES (@TaskUId, @TaskName, @TaskDescription, @TaskType, @TaskAssignee, @TaskOwner, @Status, @Start, @PlannedStart, @Finish, @CreateDate, @Priority, @Duration, @ActualEffort, @PlannedEffort, @PercentComplete, @ProjectUId, @BacklogItemNumber, @Payable, @PlannedFinish, @UnitName, @BacklogItemUId, @SprintUId);
SELECT TaskUId, TaskId, TaskName, TaskDescription, TaskType, TaskAssignee, TaskOwner, Status, Start, PlannedStart, Finish, CreateDate, Priority, Duration, ActualEffort, PlannedEffort, PercentComplete, ProjectUId, BacklogItemNumber, Payable, PlannedFinish, UnitName, BacklogItemUId, SprintUId FROM factory.Task WHERE (TaskUId = @TaskUId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TaskUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TaskUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TaskName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TaskDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@TaskType" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TaskType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TaskAssignee" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskAssignee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TaskOwner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskOwner" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Start" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PlannedStart" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="PlannedStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Finish" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Finish" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Priority" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Duration" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Duration" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ActualEffort" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ActualEffort" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@PlannedEffort" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PlannedEffort" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@PercentComplete" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PercentComplete" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@BacklogItemNumber" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="BacklogItemNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Payable" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Payable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PlannedFinish" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="PlannedFinish" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UnitName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UnitName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@BacklogItemUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="BacklogItemUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@SprintUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SprintUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TaskUId, TaskId, TaskName, TaskDescription, TaskType, TaskAssignee, TaskOwner, Status, Start, PlannedStart, Finish, CreateDate, Priority, Duration, ActualEffort, PlannedEffort, PercentComplete, ProjectUId, BacklogItemNumber, Payable, PlannedFinish, UnitName, BacklogItemUId, SprintUId FROM factory.Task</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [factory].[Task] SET [TaskUId] = @TaskUId, [TaskName] = @TaskName, [TaskDescription] = @TaskDescription, [TaskType] = @TaskType, [TaskAssignee] = @TaskAssignee, [TaskOwner] = @TaskOwner, [Status] = @Status, [Start] = @Start, [PlannedStart] = @PlannedStart, [Finish] = @Finish, [CreateDate] = @CreateDate, [Priority] = @Priority, [Duration] = @Duration, [ActualEffort] = @ActualEffort, [PlannedEffort] = @PlannedEffort, [PercentComplete] = @PercentComplete, [ProjectUId] = @ProjectUId, [BacklogItemNumber] = @BacklogItemNumber, [Payable] = @Payable, [PlannedFinish] = @PlannedFinish, [UnitName] = @UnitName, [BacklogItemUId] = @BacklogItemUId, [SprintUId] = @SprintUId WHERE (([TaskUId] = @Original_TaskUId) AND ([TaskId] = @Original_TaskId) AND ([TaskName] = @Original_TaskName) AND ((@IsNull_TaskDescription = 1 AND [TaskDescription] IS NULL) OR ([TaskDescription] = @Original_TaskDescription)) AND ([TaskType] = @Original_TaskType) AND ((@IsNull_TaskAssignee = 1 AND [TaskAssignee] IS NULL) OR ([TaskAssignee] = @Original_TaskAssignee)) AND ([TaskOwner] = @Original_TaskOwner) AND ([Status] = @Original_Status) AND ((@IsNull_Start = 1 AND [Start] IS NULL) OR ([Start] = @Original_Start)) AND ((@IsNull_PlannedStart = 1 AND [PlannedStart] IS NULL) OR ([PlannedStart] = @Original_PlannedStart)) AND ((@IsNull_Finish = 1 AND [Finish] IS NULL) OR ([Finish] = @Original_Finish)) AND ([CreateDate] = @Original_CreateDate) AND ([Priority] = @Original_Priority) AND ((@IsNull_Duration = 1 AND [Duration] IS NULL) OR ([Duration] = @Original_Duration)) AND ((@IsNull_ActualEffort = 1 AND [ActualEffort] IS NULL) OR ([ActualEffort] = @Original_ActualEffort)) AND ((@IsNull_PlannedEffort = 1 AND [PlannedEffort] IS NULL) OR ([PlannedEffort] = @Original_PlannedEffort)) AND ((@IsNull_PercentComplete = 1 AND [PercentComplete] IS NULL) OR ([PercentComplete] = @Original_PercentComplete)) AND ([ProjectUId] = @Original_ProjectUId) AND ([BacklogItemNumber] = @Original_BacklogItemNumber) AND ([Payable] = @Original_Payable) AND ((@IsNull_PlannedFinish = 1 AND [PlannedFinish] IS NULL) OR ([PlannedFinish] = @Original_PlannedFinish)) AND ([UnitName] = @Original_UnitName) AND ([BacklogItemUId] = @Original_BacklogItemUId) AND ((@IsNull_SprintUId = 1 AND [SprintUId] IS NULL) OR ([SprintUId] = @Original_SprintUId)));
SELECT TaskUId, TaskId, TaskName, TaskDescription, TaskType, TaskAssignee, TaskOwner, Status, Start, PlannedStart, Finish, CreateDate, Priority, Duration, ActualEffort, PlannedEffort, PercentComplete, ProjectUId, BacklogItemNumber, Payable, PlannedFinish, UnitName, BacklogItemUId, SprintUId FROM factory.Task WHERE (TaskUId = @TaskUId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TaskUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TaskUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TaskName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TaskDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@TaskType" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TaskType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TaskAssignee" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskAssignee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TaskOwner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskOwner" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Start" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PlannedStart" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="PlannedStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Finish" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Finish" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Priority" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Duration" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Duration" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ActualEffort" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ActualEffort" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@PlannedEffort" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PlannedEffort" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@PercentComplete" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PercentComplete" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@BacklogItemNumber" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="BacklogItemNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Payable" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Payable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PlannedFinish" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="PlannedFinish" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UnitName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UnitName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@BacklogItemUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="BacklogItemUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@SprintUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SprintUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TaskUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TaskUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TaskId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaskId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TaskName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TaskDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaskDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TaskDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_TaskType" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TaskType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TaskAssignee" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TaskAssignee" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TaskAssignee" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskAssignee" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TaskOwner" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TaskOwner" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Status" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Start" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Start" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PlannedStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlannedStart" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PlannedStart" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="PlannedStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Finish" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Finish" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Finish" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Finish" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreateDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreateDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Priority" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Duration" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Duration" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Duration" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Duration" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ActualEffort" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ActualEffort" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ActualEffort" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ActualEffort" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PlannedEffort" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlannedEffort" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_PlannedEffort" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PlannedEffort" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PercentComplete" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PercentComplete" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_PercentComplete" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PercentComplete" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_BacklogItemNumber" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="BacklogItemNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Payable" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Payable" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PlannedFinish" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PlannedFinish" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PlannedFinish" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="PlannedFinish" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UnitName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UnitName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_BacklogItemUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="BacklogItemUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SprintUId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SprintUId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_SprintUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SprintUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TaskUId" DataSetColumn="TaskUId" />
              <Mapping SourceColumn="TaskId" DataSetColumn="TaskId" />
              <Mapping SourceColumn="TaskName" DataSetColumn="TaskName" />
              <Mapping SourceColumn="TaskDescription" DataSetColumn="TaskDescription" />
              <Mapping SourceColumn="TaskType" DataSetColumn="TaskType" />
              <Mapping SourceColumn="TaskAssignee" DataSetColumn="TaskAssignee" />
              <Mapping SourceColumn="TaskOwner" DataSetColumn="TaskOwner" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="Start" DataSetColumn="Start" />
              <Mapping SourceColumn="PlannedStart" DataSetColumn="PlannedStart" />
              <Mapping SourceColumn="Finish" DataSetColumn="Finish" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="Priority" DataSetColumn="Priority" />
              <Mapping SourceColumn="Duration" DataSetColumn="Duration" />
              <Mapping SourceColumn="ActualEffort" DataSetColumn="ActualEffort" />
              <Mapping SourceColumn="PlannedEffort" DataSetColumn="PlannedEffort" />
              <Mapping SourceColumn="PercentComplete" DataSetColumn="PercentComplete" />
              <Mapping SourceColumn="ProjectUId" DataSetColumn="ProjectUId" />
              <Mapping SourceColumn="Payable" DataSetColumn="Payable" />
              <Mapping SourceColumn="PlannedFinish" DataSetColumn="PlannedFinish" />
              <Mapping SourceColumn="UnitName" DataSetColumn="UnitName" />
              <Mapping SourceColumn="BacklogItemNumber" DataSetColumn="BacklogItemNumber" />
              <Mapping SourceColumn="BacklogItemUId" DataSetColumn="BacklogItemUId" />
              <Mapping SourceColumn="SprintUId" DataSetColumn="SprintUId" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy3" GeneratorSourceName="AddsActualEffort" Modifier="Public" Name="AddsActualEffort" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="AddsActualEffort">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>
                      UPDATE factory.[Task] SET ActualEffort =  ActualEffort+ @Hours, Status=2 WHERE TASKUID = @TaskUId;
                      UPDATE [Task] SET Start=GETDATE() WHERE TASKUID = @TaskUId AND START is null;</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Hours" ColumnName="ActualEffort" DataSourceName="Factory.factory.Task" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@Hours" Precision="0" ProviderType="Float" Scale="0" Size="8" SourceColumn="ActualEffort" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TaskUId" ColumnName="TaskUId" DataSourceName="Factory.factory.Task" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@TaskUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="TaskUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="CloseTask" Modifier="Public" Name="CloseTask" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="CloseTask">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE factory.Task SET ActualEffort = ActualEffort + @Hours, Status=4, Finish = GETDATE() WHERE TaskUId = @TaskUId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Hours" ColumnName="ActualEffort" DataSourceName="FactoryDes.factory.Task" DataTypeServer="float" DbType="Double" Direction="Input" ParameterName="@Hours" Precision="0" ProviderType="Float" Scale="0" Size="8" SourceColumn="ActualEffort" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TaskUId" ColumnName="TaskUId" DataSourceName="FactoryDes.factory.Task" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@TaskUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="TaskUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="FactoryDes.factory.Task" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProjectUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByProjectUId" GeneratorSourceName="FillByProjectUId" GetMethodModifier="Public" GetMethodName="GetDataByProjectUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByProjectUId" UserSourceName="FillByProjectUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ActualEffort, BacklogItemNumber, BacklogItemUId, CreateDate, Duration, Finish, Payable, PercentComplete, PlannedEffort, PlannedFinish, PlannedStart, Priority, ProjectUId, SprintUId, Start, Status, TaskAssignee, TaskDescription, TaskId, TaskName, TaskOwner, TaskType, TaskUId, UnitName FROM factory.Task WHERE (ProjectUId = @ProjectUId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProjectUId" ColumnName="ProjectUId" DataSourceName="FactoryDes.factory.Task" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="FactoryDes.factory.Task" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProjectUIdAndAssignee" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByProjectUIdAndAssignee" GeneratorSourceName="FillByProjectUIdAndAssignee" GetMethodModifier="Public" GetMethodName="GetDataByProjectUIdAndAssignee" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByProjectUIdAndAssignee" UserSourceName="FillByProjectUIdAndAssignee">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ActualEffort, BacklogItemNumber, BacklogItemUId, CreateDate, Duration, Finish, Payable, PercentComplete, PlannedEffort, PlannedFinish, PlannedStart, Priority, ProjectUId, SprintUId, Start, Status, TaskAssignee, TaskDescription, TaskId, TaskName, TaskOwner, TaskType, TaskUId, UnitName FROM factory.Task WHERE (ProjectUId = @ProjectUId) AND (TaskAssignee = @TaskAssignee) AND (Status NOT IN (4, 5))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProjectUId" ColumnName="ProjectUId" DataSourceName="FactoryDes.factory.Task" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TaskAssignee" ColumnName="TaskAssignee" DataSourceName="FactoryDes.factory.Task" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@TaskAssignee" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="TaskAssignee" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="FactoryDes.factory.Task" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProjectUIdAndAssigneeAndSprintNumber" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByProjectUIdAndAssigneeAndSprintNumber" GeneratorSourceName="FillByProjectUIdAndAssigneeAndSprintNumber" GetMethodModifier="Public" GetMethodName="GetDataByProjectUIdAndAssigneeAndSprintNumber" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByProjectUIdAndAssigneeAndSprintNumber" UserSourceName="FillByProjectUIdAndAssigneeAndSprintNumber">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>
                      SELECT t.ActualEffort, t.BacklogItemNumber, t.BacklogItemUId, t.CreateDate, t.Duration, t.Finish, t.Payable, t.PercentComplete, t.PlannedEffort, t.PlannedFinish, t.PlannedStart, t.Priority, t.ProjectUId, t.SprintUId, t.Start, t.Status, t.TaskAssignee, t.TaskDescription, t.TaskId, t.TaskName, t.TaskOwner, t.TaskType, t.TaskUId, t.UnitName FROM factory.Task AS t INNER JOIN Sprint s ON t.SprintUId = s.SprintUId WHERE t.ProjectUId = @ProjectUId AND
                      (t.TaskAssignee = @TaskAssignee) AND (s.SprintNumber = @SprintNumber) AND (t.Status NOT IN (4, 5))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProjectUId" ColumnName="ProjectUId" DataSourceName="FactoryDes.factory.Task" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TaskAssignee" ColumnName="TaskAssignee" DataSourceName="FactoryDes.factory.Task" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@TaskAssignee" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="TaskAssignee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SprintNumber" ColumnName="SprintNumber" DataSourceName="FactoryDes.factory.Sprint" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@SprintNumber" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="SprintNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory_v1.factory.Task" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByProjectUIdAndSprintNumber" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByProjectUIdAndSprintNumber" GeneratorSourceName="FillByProjectUIdAndSprintNumber" GetMethodModifier="Public" GetMethodName="GetDataByProjectUIdAndSprintNumber" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByProjectUIdAndSprintNumber" UserSourceName="FillByProjectUIdAndSprintNumber">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT t.ActualEffort, t.BacklogItemNumber, t.BacklogItemUId, t.CreateDate, t.Duration, t.Finish, t.Payable, t.PercentComplete, t.PlannedEffort, t.PlannedFinish, t.PlannedStart, t.Priority, t.ProjectUId, t.SprintUId, t.Start, t.Status, t.TaskAssignee, t.TaskDescription, t.TaskId, t.TaskName, t.TaskOwner, t.TaskType, t.TaskUId, t.UnitName FROM factory.Task AS t INNER JOIN factory.Sprint AS s ON  (s.SprintUId = t.SprintUId) WHERE (t.ProjectUId = @ProjectUId) AND (s.SprintNumber = @SprintNumber)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProjectUId" ColumnName="ProjectUId" DataSourceName="Factory_v1.factory.Task" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SprintNumber" ColumnName="SprintNumber" DataSourceName="Factory_v1.factory.Sprint" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@SprintNumber" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="SprintNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.Task" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTaskId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTaskId" GeneratorSourceName="FillByTaskId" GetMethodModifier="Public" GetMethodName="GetDataByTaskId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTaskId" UserSourceName="FillByTaskId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ActualEffort, BacklogItemNumber, BacklogItemUId, CreateDate, Duration, Finish, Payable, PercentComplete, PlannedEffort, PlannedFinish, PlannedStart, Priority, ProjectUId, SprintUId, Start, Status, TaskAssignee, TaskDescription, TaskId, TaskName, TaskOwner, TaskType, TaskUId, UnitName FROM factory.Task WHERE (TaskId = @TaskId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TaskId" ColumnName="TaskId" DataSourceName="Factory.factory.Task" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TaskId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TaskId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.Task" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTaskUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTaskUId" GeneratorSourceName="FillByTaskUId" GetMethodModifier="Public" GetMethodName="GetDataByTaskUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTaskUId" UserSourceName="FillByTaskUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TaskUId, TaskId, TaskName, TaskDescription, TaskType, TaskAssignee, TaskOwner, Status, Start, PlannedStart, Finish, CreateDate, Priority, Duration, ActualEffort, PlannedEffort, PercentComplete, ProjectUId, BacklogItemNumber, Payable, PlannedFinish, UnitName, BacklogItemUId, SprintUId FROM factory.Task
WHERE TaskUId = @TaskUId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TaskUId" ColumnName="TaskUId" DataSourceName="Factory.factory.Task" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@TaskUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="TaskUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="FactoryDes.factory.Task" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillClosedByProjectUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetClosedDataByProjectUId" GeneratorSourceName="FillClosedByProjectUId" GetMethodModifier="Public" GetMethodName="GetClosedDataByProjectUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetClosedDataByProjectUId" UserSourceName="FillClosedByProjectUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ActualEffort, BacklogItemNumber, BacklogItemUId, CreateDate, Duration, Finish, Payable, PercentComplete, PlannedEffort, PlannedFinish, PlannedStart, Priority, ProjectUId, SprintUId, Start, Status, TaskAssignee, TaskDescription, TaskId, TaskName, TaskOwner, TaskType, TaskUId, UnitName FROM factory.Task WHERE (ProjectUId = @ProjectUId) AND (Status IN (4, 5))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProjectUId" ColumnName="ProjectUId" DataSourceName="FactoryDes.factory.Task" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="FactoryDes.factory.Task" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillClosedByProjectUIdAndSprintNumber" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetClosedByProjectUIdAndSprintNumber" GeneratorSourceName="FillClosedByProjectUIdAndSprintNumber" GetMethodModifier="Public" GetMethodName="GetClosedByProjectUIdAndSprintNumber" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetClosedByProjectUIdAndSprintNumber" UserSourceName="FillClosedByProjectUIdAndSprintNumber">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT t.ActualEffort, t.BacklogItemNumber, t.BacklogItemUId, t.CreateDate, t.Duration, t.Finish, t.Payable, t.PercentComplete, t.PlannedEffort, t.PlannedFinish, t.PlannedStart, t.Priority, t.ProjectUId, t.SprintUId, t.Start, t.Status, t.TaskAssignee, t.TaskDescription, t.TaskId, t.TaskName, t.TaskOwner, t.TaskType, t.TaskUId, t.UnitName FROM factory.Task AS t INNER JOIN Sprint AS s ON  (t.SprintUId = s.SprintUId) WHERE (t.ProjectUId = @ProjectUId) AND (s.SprintNumber = @SprintNumber) AND (t.Status IN (4, 5))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProjectUId" ColumnName="ProjectUId" DataSourceName="FactoryDes.factory.Task" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SprintNumber" ColumnName="SprintNumber" DataSourceName="FactoryDes.factory.Sprint" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@SprintNumber" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="SprintNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.Task" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillDaillyByProjectUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDaillyDataByProjectUId" GeneratorSourceName="FillDaillyByProjectUId" GetMethodModifier="Public" GetMethodName="GetDaillyDataByProjectUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDaillyDataByProjectUId" UserSourceName="FillDaillyByProjectUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ActualEffort, BacklogItemNumber, BacklogItemUId, CreateDate, Duration, Finish, Payable, PercentComplete, PlannedEffort, PlannedFinish, PlannedStart, Priority, ProjectUId, SprintUId, Start, Status, TaskAssignee, TaskDescription, TaskId, TaskName, TaskOwner, TaskType, TaskUId, UnitName FROM factory.Task WHERE (ProjectUId = @ProjectUId) AND (Status NOT IN (4, 5)) OR (ProjectUId = @ProjectUId) AND (DATEDIFF(day, Finish, GETDATE()) &lt;= @DATEDELAY)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProjectUId" ColumnName="ProjectUId" DataSourceName="Factory.factory.Task" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="DATEDELAY" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Decimal" Direction="Input" ParameterName="@DATEDELAY" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="FactoryDes.factory.Task" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillOpenedByProjectUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetOpenedDataByProjectUId" GeneratorSourceName="FillOpenedByProjectUId" GetMethodModifier="Public" GetMethodName="GetOpenedDataByProjectUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetOpenedDataByProjectUId" UserSourceName="FillOpenedByProjectUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ActualEffort, BacklogItemNumber, BacklogItemUId, CreateDate, Duration, Finish, Payable, PercentComplete, PlannedEffort, PlannedFinish, PlannedStart, Priority, ProjectUId, SprintUId, Start, Status, TaskAssignee, TaskDescription, TaskId, TaskName, TaskOwner, TaskType, TaskUId, UnitName FROM factory.Task WHERE (ProjectUId = @ProjectUId) AND (Status NOT IN (4, 5))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProjectUId" ColumnName="ProjectUId" DataSourceName="FactoryDes.factory.Task" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="FactoryDes.factory.Task" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillOpenedByProjectUIdAndSprintNumber" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetOpenedByProjectUIdAndSprintNumber" GeneratorSourceName="FillOpenedByProjectUIdAndSprintNumber" GetMethodModifier="Public" GetMethodName="GetOpenedByProjectUIdAndSprintNumber" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetOpenedByProjectUIdAndSprintNumber" UserSourceName="FillOpenedByProjectUIdAndSprintNumber">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT t.ActualEffort, t.BacklogItemNumber, t.BacklogItemUId, t.CreateDate, t.Duration, t.Finish, t.Payable, t.PercentComplete, t.PlannedEffort, t.PlannedFinish, t.PlannedStart, t.Priority, t.ProjectUId, t.SprintUId, t.Start, t.Status, t.TaskAssignee, t.TaskDescription, t.TaskId, t.TaskName, t.TaskOwner, t.TaskType, t.TaskUId, t.UnitName FROM factory.Task AS t INNER JOIN Sprint AS s ON (s.SprintUId = t.SprintUId) WHERE (t.ProjectUId = @ProjectUId) AND (s.SprintNumber = @SprintNumber) AND (t.Status NOT IN (4, 5))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProjectUId" ColumnName="ProjectUId" DataSourceName="FactoryDes.factory.Task" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SprintNumber" ColumnName="SprintNumber" DataSourceName="FactoryDes.factory.Sprint" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@SprintNumber" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="SprintNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="ScalarUserActualMonthEffort" Modifier="Public" Name="ScalarUserActualMonthEffort" QueryType="Scalar" ScalarCallRetval="System.Double, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="ScalarUserActualMonthEffort">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT SUM(ISNULL(ActualEffort,0)) FROM factory.Task WHERE MONTH(Finish)=@FinishMonth and YEAR(Finish) =@Year and TaskAssignee=@TaskAssignee</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="FinishMonth" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Decimal" Direction="Input" ParameterName="@FinishMonth" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Year" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Decimal" Direction="Input" ParameterName="@Year" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TaskAssignee" ColumnName="TaskAssignee" DataSourceName="Factory.factory.Task" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@TaskAssignee" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="TaskAssignee" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy2" GeneratorSourceName="ScalarUserPlannedEffort" Modifier="Public" Name="ScalarUserPlannedEffort" QueryType="Scalar" ScalarCallRetval="System.Double, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="ScalarUserPlannedEffort">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT SUM(ISNULL(plannedEffort,0)) FROM factory.Task where status = 1 and TaskAssignee = @TaskAssignee</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="TaskAssignee" ColumnName="TaskAssignee" DataSourceName="Factory.factory.Task" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@TaskAssignee" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="TaskAssignee" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateTaskBacklogItemStatus" Modifier="Public" Name="UpdateTaskBacklogItemStatus" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="UpdateTaskBacklogItemStatus">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>
                      UPDATE factory.BacklogItem set status =1, startdate = getdate()
                      where BacklogItemUId = (SELECT BacklogItemUID from factory.task where taskUId=@TaskUId) and status=0</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TaskUId" ColumnName="" DataSourceName="" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@TaskUId" Precision="0" Scale="0" Size="38" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TaskResumeTableAdapter" GeneratorDataComponentClassName="TaskResumeTableAdapter" Name="TaskResume" UserDataComponentName="TaskResumeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.TaskResume" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        TaskId, TaskUId, TaskName, TaskOwner, Status, Start, CreateDate, Priority, Duration, ActualEffort, PlannedEffort, PercentComplete, ProjectUId, PlannedFinish, 
                         UnitName, Payable, ProjectName, ProjectNumber, ClientName, TaskAssignee, Title, BacklogItemNumber, TaskType, BacklogItemUId, Finish
FROM            factory.TaskResume</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TaskId" DataSetColumn="TaskId" />
              <Mapping SourceColumn="TaskUId" DataSetColumn="TaskUId" />
              <Mapping SourceColumn="TaskName" DataSetColumn="TaskName" />
              <Mapping SourceColumn="TaskOwner" DataSetColumn="TaskOwner" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="Start" DataSetColumn="Start" />
              <Mapping SourceColumn="CreateDate" DataSetColumn="CreateDate" />
              <Mapping SourceColumn="Priority" DataSetColumn="Priority" />
              <Mapping SourceColumn="Duration" DataSetColumn="Duration" />
              <Mapping SourceColumn="ActualEffort" DataSetColumn="ActualEffort" />
              <Mapping SourceColumn="PlannedEffort" DataSetColumn="PlannedEffort" />
              <Mapping SourceColumn="PercentComplete" DataSetColumn="PercentComplete" />
              <Mapping SourceColumn="ProjectUId" DataSetColumn="ProjectUId" />
              <Mapping SourceColumn="PlannedFinish" DataSetColumn="PlannedFinish" />
              <Mapping SourceColumn="UnitName" DataSetColumn="UnitName" />
              <Mapping SourceColumn="Payable" DataSetColumn="Payable" />
              <Mapping SourceColumn="ProjectName" DataSetColumn="ProjectName" />
              <Mapping SourceColumn="ProjectNumber" DataSetColumn="ProjectNumber" />
              <Mapping SourceColumn="ClientName" DataSetColumn="ClientName" />
              <Mapping SourceColumn="TaskAssignee" DataSetColumn="TaskAssignee" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="BacklogItemNumber" DataSetColumn="BacklogItemNumber" />
              <Mapping SourceColumn="TaskType" DataSetColumn="TaskType" />
              <Mapping SourceColumn="BacklogItemUId" DataSetColumn="BacklogItemUId" />
              <Mapping SourceColumn="Finish" DataSetColumn="Finish" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory_v1.factory.TaskResume" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByArtifactPath" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByArtifactPath" GeneratorSourceName="FillByArtifactPath" GetMethodModifier="Public" GetMethodName="GetDataByArtifactPath" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByArtifactPath" UserSourceName="FillByArtifactPath">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT t.ActualEffort, t.BacklogItemNumber, t.BacklogItemUId, t.ClientName, t.CreateDate, t.Duration, t.Finish, t.Payable, t.PercentComplete, t.PlannedEffort, t.PlannedFinish, t.Priority, t.ProjectName, t.ProjectNumber, t.ProjectUId, t.Start, t.Status, t.TaskAssignee, t.TaskId, t.TaskName, t.TaskOwner, t.TaskType, t.TaskUId, t.Title, t.UnitName FROM factory.TaskResume AS t INNER JOIN factory.TaskTail AS tt ON t.TaskUId = tt.TaskUId AND tt.ArtifactPath = @ArtifactPath</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ArtifactPath" ColumnName="ArtifactPath" DataSourceName="Factory_v1.factory.TaskTail" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@ArtifactPath" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="ArtifactPath" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.TaskResume" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByTailedBacklogItemUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTailedBacklogItemUId" GeneratorSourceName="FillByTailedBacklogItemUId" GetMethodModifier="Public" GetMethodName="GetDataByTailedBacklogItemUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTailedBacklogItemUId" UserSourceName="FillByTailedBacklogItemUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DISTINCT tr.* FROM factory.TaskResume tr
inner join factory.tasktailresume ttr on tr.taskUId = ttr.taskUId and ttr.BacklogItemUid = @BacklogItemUId
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="BacklogItemUId" ColumnName="BacklogItemUId" DataSourceName="Factory.factory.TaskTailResume" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@BacklogItemUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="BacklogItemUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.TaskResume" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByTailedProjectUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTailedProjectUId" GeneratorSourceName="FillByTailedProjectUId" GetMethodModifier="Public" GetMethodName="GetDataByTailedProjectUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTailedProjectUId" UserSourceName="FillByTailedProjectUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DISTINCT tr.* FROM factory.TaskResume tr
inner join factory.tasktailresume ttr on tr.taskUId = ttr.taskUId and ttr.ProjectUid = @ProjectUId
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProjectUId" ColumnName="ProjectUId" DataSourceName="Factory.factory.TaskTailResume" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.TaskResume" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByTailUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTailUId" GeneratorSourceName="FillByTailUId" GetMethodModifier="Public" GetMethodName="GetDataByTailUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTailUId" UserSourceName="FillByTailUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT t.ActualEffort, t.BacklogItemNumber, t.BacklogItemUId, t.ClientName, t.CreateDate, t.Duration, t.Finish, t.Payable, t.PercentComplete, t.PlannedEffort, t.PlannedFinish, t.Priority, t.ProjectName, t.ProjectNumber, t.ProjectUId, t.Start, t.Status, t.TaskAssignee, t.TaskId, t.TaskName, t.TaskOwner, t.TaskType, t.TaskUId, t.Title, t.UnitName FROM factory.TaskResume AS t INNER JOIN factory.TaskTail AS tt ON t.TaskUId = tt.TaskUId AND tt.TaskTailUId = @TaskTailUId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TaskTailUId" ColumnName="TaskTailUId" DataSourceName="Factory.factory.TaskTail" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@TaskTailUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="TaskTailUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.TaskResume" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillOpened" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetOpenedData" GeneratorSourceName="FillOpened" GetMethodModifier="Public" GetMethodName="GetOpenedData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetOpenedData" UserSourceName="FillOpened">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ActualEffort, BacklogItemNumber, BacklogItemUId, ClientName, CreateDate, Duration, Finish, Payable, PercentComplete, PlannedEffort, PlannedFinish, Priority, ProjectName, ProjectNumber, ProjectUId, Start, Status, TaskAssignee, TaskId, TaskName, TaskOwner, TaskType, TaskUId, Title, UnitName FROM factory.TaskResume WHERE (Status NOT IN (4, 5))</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.TaskResume" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillOpenedByAssignee" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetOpenedDataByAssignee" GeneratorSourceName="FillOpenedByAssignee" GetMethodModifier="Public" GetMethodName="GetOpenedDataByAssignee" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetOpenedDataByAssignee" UserSourceName="FillOpenedByAssignee">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ActualEffort, BacklogItemNumber, BacklogItemUId, ClientName, CreateDate, Duration, Finish, Payable, PercentComplete, PlannedEffort, PlannedFinish, Priority, ProjectName, ProjectNumber, ProjectUId, Start, Status, TaskAssignee, TaskId, TaskName, TaskOwner, TaskType, TaskUId, Title, UnitName FROM factory.TaskResume WHERE (TaskAssignee = @TaskAssignee) AND (Status NOT IN (4, 5))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="TaskAssignee" ColumnName="TaskAssignee" DataSourceName="FactoryDes.factory.TaskResume" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@TaskAssignee" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="TaskAssignee" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TaskTailTableAdapter" GeneratorDataComponentClassName="TaskTailTableAdapter" Name="TaskTail" UserDataComponentName="TaskTailTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.TaskTail" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [factory].[TaskTail] WHERE (([TaskTailUId] = @Original_TaskTailUId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TaskTailUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TaskTailUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [factory].[TaskTail] ([TaskTailUId], [ArtifactPath], [ArtifactRevision], [ArtifactExtension], [TaskUId], [CheckInTime], [RepositoryUrl], [ProjectUId], [IsSourceControled]) VALUES (@TaskTailUId, @ArtifactPath, @ArtifactRevision, @ArtifactExtension, @TaskUId, @CheckInTime, @RepositoryUrl, @ProjectUId, @IsSourceControled);
SELECT TaskTailUId, ArtifactPath, ArtifactRevision, ArtifactExtension, TaskUId, CheckInTime, RepositoryUrl, ProjectUId, IsSourceControled FROM factory.TaskTail WHERE (TaskTailUId = @TaskTailUId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TaskTailUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TaskTailUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ArtifactPath" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArtifactPath" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ArtifactRevision" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArtifactRevision" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ArtifactExtension" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArtifactExtension" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TaskUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TaskUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CheckInTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CheckInTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RepositoryUrl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RepositoryUrl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsSourceControled" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsSourceControled" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        TaskTailUId, ArtifactPath, ArtifactRevision, ArtifactExtension, TaskUId, CheckInTime, RepositoryUrl, ProjectUId, IsSourceControled
FROM            factory.TaskTail</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [factory].[TaskTail] SET [TaskTailUId] = @TaskTailUId, [ArtifactPath] = @ArtifactPath, [ArtifactRevision] = @ArtifactRevision, [ArtifactExtension] = @ArtifactExtension, [TaskUId] = @TaskUId, [CheckInTime] = @CheckInTime, [RepositoryUrl] = @RepositoryUrl, [ProjectUId] = @ProjectUId, [IsSourceControled] = @IsSourceControled WHERE (([TaskTailUId] = @Original_TaskTailUId));
SELECT TaskTailUId, ArtifactPath, ArtifactRevision, ArtifactExtension, TaskUId, CheckInTime, RepositoryUrl, ProjectUId, IsSourceControled FROM factory.TaskTail WHERE (TaskTailUId = @TaskTailUId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TaskTailUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TaskTailUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ArtifactPath" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArtifactPath" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ArtifactRevision" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ArtifactRevision" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ArtifactExtension" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ArtifactExtension" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@TaskUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TaskUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CheckInTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CheckInTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RepositoryUrl" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RepositoryUrl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsSourceControled" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsSourceControled" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_TaskTailUId" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="TaskTailUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TaskTailUId" DataSetColumn="TaskTailUId" />
              <Mapping SourceColumn="ArtifactPath" DataSetColumn="ArtifactPath" />
              <Mapping SourceColumn="ArtifactRevision" DataSetColumn="ArtifactRevision" />
              <Mapping SourceColumn="ArtifactExtension" DataSetColumn="ArtifactExtension" />
              <Mapping SourceColumn="TaskUId" DataSetColumn="TaskUId" />
              <Mapping SourceColumn="CheckInTime" DataSetColumn="CheckInTime" />
              <Mapping SourceColumn="RepositoryUrl" DataSetColumn="RepositoryUrl" />
              <Mapping SourceColumn="ProjectUId" DataSetColumn="ProjectUId" />
              <Mapping SourceColumn="IsSourceControled" DataSetColumn="IsSourceControled" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteByArtifactPathAndBacklogItemUId" Modifier="Public" Name="DeleteByArtifactPathAndBacklogItemUId" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteByArtifactPathAndBacklogItemUId">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM factory.TaskTail WHERE ArtifactPath=@ArtifactPath AND  TaskUId IN (SELECT TaskUId                            FROM factory.Task  WHERE  BacklogItemUId = @BacklogItemUId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ArtifactPath" ColumnName="ArtifactPath" DataSourceName="Factory.factory.TaskTail" DataTypeServer="varchar(255)" DbType="AnsiString" Direction="Input" ParameterName="@ArtifactPath" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="ArtifactPath" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="BacklogItemUId" ColumnName="" DataSourceName="" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@BacklogItemUId" Precision="0" Scale="0" Size="38" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteByTaskTailUId" Modifier="Public" Name="DeleteByTaskTailUId" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="DeleteByTaskTailUId">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE TaskTail WHERE TaskTailUId=@TaskTailUId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TaskTailUId" ColumnName="TaskTailUId" DataSourceName="Factory.factory.TaskTail" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@TaskTailUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="TaskTailUId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory_v1.factory.TaskTailResume" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillArtifactsByProjectUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetArtifactsDataByProjectUId" GeneratorSourceName="FillArtifactsByProjectUId" GetMethodModifier="Public" GetMethodName="GetArtifactsDataByProjectUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetArtifactsDataByProjectUId" UserSourceName="FillArtifactsByProjectUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ArtifactExtension, ArtifactPath, MAX(ArtifactRevision) AS ArtifactRevision, MAX(CheckInTime) AS CheckInTime, ProjectUId, RepositoryUrl, MAX(TaskTailUId) AS TaskTailUId, 
                         MAX(TaskUId) AS TaskUId, IsSourceControled
FROM            factory.TaskTailResume
WHERE ProjectUId = @ProjectUId
GROUP BY ProjectUId, RepositoryUrl, ArtifactPath, ArtifactExtension, IsSourceControled</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProjectUId" ColumnName="ProjectUId" DataSourceName="Factory_v1.factory.TaskTailResume" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.TaskTail" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByBacklogItemUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByBacklogItemUId" GeneratorSourceName="FillByBacklogItemUId" GetMethodModifier="Public" GetMethodName="GetDataByBacklogItemUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByBacklogItemUId" UserSourceName="FillByBacklogItemUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ArtifactExtension, ArtifactPath, MAX(ArtifactRevision) AS ArtifactRevision, MAX(CheckInTime) AS CheckInTime, ProjectUId, RepositoryUrl, MAX(TaskTailUId) AS TaskTailUId, 
                         MAX(TaskUId) AS TaskUId, IsSourceControled
FROM            factory.TaskTail
WHERE        (TaskUId IN
                             (SELECT        TaskUId
                               FROM            factory.Task
                               WHERE        (BacklogItemUId = @BacklogItemUId)))
GROUP BY ProjectUId, RepositoryUrl, ArtifactPath, ArtifactExtension, IsSourceControled</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="BacklogItemUId" ColumnName="" DataSourceName="" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@BacklogItemUId" Precision="0" Scale="0" Size="38" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory_v1.factory.TaskTailResume" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByProjectUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByProjectUId" GeneratorSourceName="FillByProjectUId" GetMethodModifier="Public" GetMethodName="GetDataByProjectUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByProjectUId" UserSourceName="FillByProjectUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ArtifactExtension, ArtifactPath, MAX(ArtifactRevision) AS ArtifactRevision, MAX(CheckInTime) AS CheckInTime, ProjectUId, RepositoryUrl, MAX(TaskTailUId) AS TaskTailUId, 
                         MAX(TaskUId) AS TaskUId, IsSourceControled
,[BacklogItemUId]
      ,[Title]
      ,[BacklogItemNumber]
      ,[Status]
FROM            factory.TaskTailResume
WHERE ProjectUId = @ProjectUId
GROUP BY ProjectUId, RepositoryUrl, ArtifactPath, ArtifactExtension, backlogitemuid, title, backlogitemnumber, status, IsSourceControled</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProjectUId" ColumnName="ProjectUId" DataSourceName="Factory_v1.factory.TaskTailResume" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.TaskTail" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTaskUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTaskUId" GeneratorSourceName="FillByTaskUId" GetMethodModifier="Public" GetMethodName="GetDataByTaskUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTaskUId" UserSourceName="FillByTaskUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ArtifactExtension, ArtifactPath, ArtifactRevision, CheckInTime, IsSourceControled, ProjectUId, RepositoryUrl, TaskTailUId, TaskUId FROM factory.TaskTail WHERE (TaskUId = @TaskUId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TaskUId" ColumnName="TaskUId" DataSourceName="Factory.factory.TaskTail" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@TaskUId" Precision="0" Scale="0" Size="38" SourceColumn="TaskUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.TailTaskByTaskUId" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="TailTaskByTaskUId" Modifier="Public" Name="TailTaskByTaskUId" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="TailTaskByTaskUId">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>factory.TailTaskByTaskUId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@taskTailUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="char" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@taskUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@artifactPath" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@artifactRevision" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@artifactExtension" Precision="0" ProviderType="VarChar" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@checkIntime" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@repositoryUrl" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isSourceControled" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TaskTailImpactedItemTableAdapter" GeneratorDataComponentClassName="TaskTailImpactedItemTableAdapter" Name="TaskTailImpactedItem" UserDataComponentName="TaskTailImpactedItemTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.TaskTailImpactedItem" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SourceBacklogItemUId, ProjectUId, ProjectName, ProjectNumber, BacklogItemUId, Title, BacklogItemNumber, Status FROM factory.TaskTailImpactedItem</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SourceBacklogItemUId" DataSetColumn="SourceBacklogItemUId" />
              <Mapping SourceColumn="ProjectUId" DataSetColumn="ProjectUId" />
              <Mapping SourceColumn="ProjectName" DataSetColumn="ProjectName" />
              <Mapping SourceColumn="ProjectNumber" DataSetColumn="ProjectNumber" />
              <Mapping SourceColumn="BacklogItemUId" DataSetColumn="BacklogItemUId" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="BacklogItemNumber" DataSetColumn="BacklogItemNumber" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.TaskTailImpactedItem" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByProjectUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByProjectUId" GeneratorSourceName="FillByProjectUId" GetMethodModifier="Public" GetMethodName="GetDataByProjectUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByProjectUId" UserSourceName="FillByProjectUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>
                      SELECT DISTINCT SourceBacklogItemUId, ProjectUId, ProjectName, ProjectNumber, BacklogItemUId, Title, BacklogItemNumber, Status
                      FROM            factory.TaskTailImpactedItem
                      WHERE        (SourceBacklogItemUId IN
                      (SELECT        BacklogItemUId
                      FROM            factory.BacklogItem
                      WHERE        (ProjectUId = @ProjectUId)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="ProjectUId" ColumnName="ProjectUId" DataSourceName="Factory.factory.TaskTailImpactedItem" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@ProjectUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="ProjectUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.TaskTailImpactedItem" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillBySourceBacklogItemUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySourceBacklogItemUId" GeneratorSourceName="FillBySourceBacklogItemUId" GetMethodModifier="Public" GetMethodName="GetDataBySourceBacklogItemUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySourceBacklogItemUId" UserSourceName="FillBySourceBacklogItemUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DISTINCT SourceBacklogItemUId, ProjectUId, ProjectName, ProjectNumber, BacklogItemUId, Title, BacklogItemNumber, Status FROM factory.TaskTailImpactedItem WHERE SourceBacklogItemUId = @SourceBacklogItemUId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="SourceBacklogItemUId" ColumnName="SourceBacklogItemUId" DataSourceName="Factory.factory.TaskTailImpactedItem" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@SourceBacklogItemUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="SourceBacklogItemUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.TaskTailResume" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByTailUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTailUId" GeneratorSourceName="FillByTailUId" GetMethodModifier="Public" GetMethodName="GetDataByTailUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTailUId" UserSourceName="FillByTailUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DISTINCT t1.BacklogItemUId AS SourceBacklogItemUId, t2.ProjectUId, t2.ProjectName,	t2.ProjectNumber, t2.BacklogItemUId, t2.Title, t2.BacklogItemNumber, t2.Status
FROM factory.TaskTailResume AS t1 INNER JOIN factory.TaskTailResume AS t2 ON t1.ArtifactPath = t2.ArtifactPath AND t1.RepositoryUrl = t2.RepositoryUrl AND t1.BacklogItemUId &lt;&gt; t2.BacklogItemUId AND t1.TaskTailUId = @TaskTailUId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TaskTailUId" ColumnName="TaskTailUId" DataSourceName="Factory.factory.TaskTailResume" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@TaskTailUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="TaskTailUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.TaskTailResume" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByTaskUId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTaskUId" GeneratorSourceName="FillByTaskUId" GetMethodModifier="Public" GetMethodName="GetDataByTaskUId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTaskUId" UserSourceName="FillByTaskUId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DISTINCT    t1.BacklogItemUId AS SourceBacklogItemUId, t2.ProjectUId, t2.ProjectName, t2.ProjectNumber, t2.BacklogItemUId, t2.Title, t2.BacklogItemNumber, t2.Status
FROM         factory.TaskTailResume AS t1 INNER JOIN
                      factory.TaskTailResume AS t2 ON t1.ArtifactPath = t2.ArtifactPath AND t1.RepositoryUrl = t2.RepositoryUrl
and t1.TaskUId = @TaskUId
AND t1.BacklogItemUId &lt;&gt; t2.BacklogItemUId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="TaskUId" ColumnName="TaskUId" DataSourceName="Factory.factory.TaskTailResume" DataTypeServer="char(38)" DbType="AnsiString" Direction="Input" ParameterName="@TaskUId" Precision="0" ProviderType="Char" Scale="0" Size="38" SourceColumn="TaskUId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AverageHoursBySizeItemTypeTableAdapter" GeneratorDataComponentClassName="AverageHoursBySizeItemTypeTableAdapter" Name="AverageHoursBySizeItemType" UserDataComponentName="AverageHoursBySizeItemTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="FactoryConnectionString (Settings)" DbObjectName="Factory.factory.AverageHoursBySizeItemType" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SizeItemType, UnitName, Hours FROM factory.AverageHoursBySizeItemType</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SizeItemType" DataSetColumn="SizeItemType" />
              <Mapping SourceColumn="UnitName" DataSetColumn="UnitName" />
              <Mapping SourceColumn="Hours" DataSetColumn="Hours" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="TaskDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="TaskDataSet" msprop:Generator_DataSetName="TaskDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Task" msprop:Generator_UserTableName="Task" msprop:Generator_RowDeletedName="TaskRowDeleted" msprop:Generator_RowChangedName="TaskRowChanged" msprop:Generator_RowClassName="TaskRow" msprop:Generator_RowChangingName="TaskRowChanging" msprop:Generator_RowEvArgName="TaskRowChangeEvent" msprop:Generator_RowEvHandlerName="TaskRowChangeEventHandler" msprop:Generator_TableClassName="TaskDataTable" msprop:Generator_TableVarName="tableTask" msprop:Generator_RowDeletingName="TaskRowDeleting" msprop:Generator_TablePropName="Task">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TaskUId" msprop:Generator_UserColumnName="TaskUId" msprop:Generator_ColumnVarNameInTable="columnTaskUId" msprop:Generator_ColumnPropNameInRow="TaskUId" msprop:Generator_ColumnPropNameInTable="TaskUIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TaskId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="TaskId" msprop:Generator_ColumnVarNameInTable="columnTaskId" msprop:Generator_ColumnPropNameInRow="TaskId" msprop:Generator_ColumnPropNameInTable="TaskIdColumn" type="xs:int" />
              <xs:element name="TaskName" msprop:Generator_UserColumnName="TaskName" msprop:Generator_ColumnVarNameInTable="columnTaskName" msprop:Generator_ColumnPropNameInRow="TaskName" msprop:Generator_ColumnPropNameInTable="TaskNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TaskDescription" msprop:Generator_UserColumnName="TaskDescription" msprop:Generator_ColumnVarNameInTable="columnTaskDescription" msprop:Generator_ColumnPropNameInRow="TaskDescription" msprop:Generator_ColumnPropNameInTable="TaskDescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TaskType" msprop:Generator_UserColumnName="TaskType" msprop:Generator_ColumnVarNameInTable="columnTaskType" msprop:Generator_ColumnPropNameInRow="TaskType" msprop:Generator_ColumnPropNameInTable="TaskTypeColumn" type="xs:short" />
              <xs:element name="TaskAssignee" msprop:Generator_UserColumnName="TaskAssignee" msprop:Generator_ColumnVarNameInTable="columnTaskAssignee" msprop:Generator_ColumnPropNameInRow="TaskAssignee" msprop:Generator_ColumnPropNameInTable="TaskAssigneeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TaskOwner" msprop:Generator_UserColumnName="TaskOwner" msprop:Generator_ColumnVarNameInTable="columnTaskOwner" msprop:Generator_ColumnPropNameInRow="TaskOwner" msprop:Generator_ColumnPropNameInTable="TaskOwnerColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" type="xs:short" />
              <xs:element name="Start" msprop:Generator_UserColumnName="Start" msprop:Generator_ColumnVarNameInTable="columnStart" msprop:Generator_ColumnPropNameInRow="Start" msprop:Generator_ColumnPropNameInTable="StartColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PlannedStart" msprop:Generator_UserColumnName="PlannedStart" msprop:Generator_ColumnVarNameInTable="columnPlannedStart" msprop:Generator_ColumnPropNameInRow="PlannedStart" msprop:Generator_ColumnPropNameInTable="PlannedStartColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Finish" msprop:Generator_UserColumnName="Finish" msprop:Generator_ColumnVarNameInTable="columnFinish" msprop:Generator_ColumnPropNameInRow="Finish" msprop:Generator_ColumnPropNameInTable="FinishColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CreateDate" msprop:Generator_UserColumnName="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" type="xs:dateTime" />
              <xs:element name="Priority" msprop:Generator_UserColumnName="Priority" msprop:Generator_ColumnVarNameInTable="columnPriority" msprop:Generator_ColumnPropNameInRow="Priority" msprop:Generator_ColumnPropNameInTable="PriorityColumn" type="xs:short" />
              <xs:element name="Duration" msprop:Generator_UserColumnName="Duration" msprop:Generator_ColumnVarNameInTable="columnDuration" msprop:Generator_ColumnPropNameInRow="Duration" msprop:Generator_ColumnPropNameInTable="DurationColumn" type="xs:double" minOccurs="0" />
              <xs:element name="ActualEffort" msprop:Generator_UserColumnName="ActualEffort" msprop:Generator_ColumnVarNameInTable="columnActualEffort" msprop:Generator_ColumnPropNameInRow="ActualEffort" msprop:Generator_ColumnPropNameInTable="ActualEffortColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PlannedEffort" msprop:Generator_UserColumnName="PlannedEffort" msprop:Generator_ColumnVarNameInTable="columnPlannedEffort" msprop:Generator_ColumnPropNameInRow="PlannedEffort" msprop:Generator_ColumnPropNameInTable="PlannedEffortColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PercentComplete" msprop:Generator_UserColumnName="PercentComplete" msprop:Generator_ColumnVarNameInTable="columnPercentComplete" msprop:Generator_ColumnPropNameInRow="PercentComplete" msprop:Generator_ColumnPropNameInTable="PercentCompleteColumn" type="xs:double" minOccurs="0" />
              <xs:element name="ProjectUId" msprop:Generator_UserColumnName="ProjectUId" msprop:Generator_ColumnVarNameInTable="columnProjectUId" msprop:Generator_ColumnPropNameInRow="ProjectUId" msprop:Generator_ColumnPropNameInTable="ProjectUIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BacklogItemNumber" msprop:Generator_UserColumnName="BacklogItemNumber" msprop:Generator_ColumnVarNameInTable="columnBacklogItemNumber" msprop:Generator_ColumnPropNameInRow="BacklogItemNumber" msprop:Generator_ColumnPropNameInTable="BacklogItemNumberColumn" type="xs:short" />
              <xs:element name="Payable" msprop:Generator_UserColumnName="Payable" msprop:Generator_ColumnVarNameInTable="columnPayable" msprop:Generator_ColumnPropNameInRow="Payable" msprop:Generator_ColumnPropNameInTable="PayableColumn" type="xs:boolean" />
              <xs:element name="PlannedFinish" msprop:Generator_UserColumnName="PlannedFinish" msprop:Generator_ColumnVarNameInTable="columnPlannedFinish" msprop:Generator_ColumnPropNameInRow="PlannedFinish" msprop:Generator_ColumnPropNameInTable="PlannedFinishColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="UnitName" msprop:Generator_UserColumnName="UnitName" msprop:Generator_ColumnVarNameInTable="columnUnitName" msprop:Generator_ColumnPropNameInRow="UnitName" msprop:Generator_ColumnPropNameInTable="UnitNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BacklogItemUId" msprop:Generator_UserColumnName="BacklogItemUId" msprop:Generator_ColumnPropNameInRow="BacklogItemUId" msprop:Generator_ColumnVarNameInTable="columnBacklogItemUId" msprop:Generator_ColumnPropNameInTable="BacklogItemUIdColumn" type="xs:string" />
              <xs:element name="SprintUId" msprop:Generator_UserColumnName="SprintUId" msprop:Generator_ColumnVarNameInTable="columnSprintUId" msprop:Generator_ColumnPropNameInRow="SprintUId" msprop:Generator_ColumnPropNameInTable="SprintUIdColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TaskResume" msprop:Generator_UserTableName="TaskResume" msprop:Generator_RowDeletedName="TaskResumeRowDeleted" msprop:Generator_RowChangedName="TaskResumeRowChanged" msprop:Generator_RowClassName="TaskResumeRow" msprop:Generator_RowChangingName="TaskResumeRowChanging" msprop:Generator_RowEvArgName="TaskResumeRowChangeEvent" msprop:Generator_RowEvHandlerName="TaskResumeRowChangeEventHandler" msprop:Generator_TableClassName="TaskResumeDataTable" msprop:Generator_TableVarName="tableTaskResume" msprop:Generator_RowDeletingName="TaskResumeRowDeleting" msprop:Generator_TablePropName="TaskResume">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TaskId" msprop:Generator_UserColumnName="TaskId" msprop:Generator_ColumnVarNameInTable="columnTaskId" msprop:Generator_ColumnPropNameInRow="TaskId" msprop:Generator_ColumnPropNameInTable="TaskIdColumn" type="xs:int" />
              <xs:element name="TaskUId" msprop:Generator_UserColumnName="TaskUId" msprop:Generator_ColumnVarNameInTable="columnTaskUId" msprop:Generator_ColumnPropNameInRow="TaskUId" msprop:Generator_ColumnPropNameInTable="TaskUIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TaskName" msprop:Generator_UserColumnName="TaskName" msprop:Generator_ColumnVarNameInTable="columnTaskName" msprop:Generator_ColumnPropNameInRow="TaskName" msprop:Generator_ColumnPropNameInTable="TaskNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TaskOwner" msprop:Generator_UserColumnName="TaskOwner" msprop:Generator_ColumnVarNameInTable="columnTaskOwner" msprop:Generator_ColumnPropNameInRow="TaskOwner" msprop:Generator_ColumnPropNameInTable="TaskOwnerColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnPropNameInTable="StatusColumn" type="xs:short" />
              <xs:element name="Start" msprop:Generator_UserColumnName="Start" msprop:Generator_ColumnVarNameInTable="columnStart" msprop:Generator_ColumnPropNameInRow="Start" msprop:Generator_ColumnPropNameInTable="StartColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CreateDate" msprop:Generator_UserColumnName="CreateDate" msprop:Generator_ColumnVarNameInTable="columnCreateDate" msprop:Generator_ColumnPropNameInRow="CreateDate" msprop:Generator_ColumnPropNameInTable="CreateDateColumn" type="xs:dateTime" />
              <xs:element name="Priority" msprop:Generator_UserColumnName="Priority" msprop:Generator_ColumnVarNameInTable="columnPriority" msprop:Generator_ColumnPropNameInRow="Priority" msprop:Generator_ColumnPropNameInTable="PriorityColumn" type="xs:short" />
              <xs:element name="Duration" msprop:Generator_UserColumnName="Duration" msprop:Generator_ColumnVarNameInTable="columnDuration" msprop:Generator_ColumnPropNameInRow="Duration" msprop:Generator_ColumnPropNameInTable="DurationColumn" type="xs:double" minOccurs="0" />
              <xs:element name="ActualEffort" msprop:Generator_UserColumnName="ActualEffort" msprop:Generator_ColumnVarNameInTable="columnActualEffort" msprop:Generator_ColumnPropNameInRow="ActualEffort" msprop:Generator_ColumnPropNameInTable="ActualEffortColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PlannedEffort" msprop:Generator_UserColumnName="PlannedEffort" msprop:Generator_ColumnVarNameInTable="columnPlannedEffort" msprop:Generator_ColumnPropNameInRow="PlannedEffort" msprop:Generator_ColumnPropNameInTable="PlannedEffortColumn" type="xs:double" minOccurs="0" />
              <xs:element name="PercentComplete" msprop:Generator_UserColumnName="PercentComplete" msprop:Generator_ColumnVarNameInTable="columnPercentComplete" msprop:Generator_ColumnPropNameInRow="PercentComplete" msprop:Generator_ColumnPropNameInTable="PercentCompleteColumn" type="xs:double" minOccurs="0" />
              <xs:element name="ProjectUId" msprop:Generator_UserColumnName="ProjectUId" msprop:Generator_ColumnVarNameInTable="columnProjectUId" msprop:Generator_ColumnPropNameInRow="ProjectUId" msprop:Generator_ColumnPropNameInTable="ProjectUIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PlannedFinish" msprop:Generator_UserColumnName="PlannedFinish" msprop:Generator_ColumnVarNameInTable="columnPlannedFinish" msprop:Generator_ColumnPropNameInRow="PlannedFinish" msprop:Generator_ColumnPropNameInTable="PlannedFinishColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="UnitName" msprop:Generator_UserColumnName="UnitName" msprop:Generator_ColumnVarNameInTable="columnUnitName" msprop:Generator_ColumnPropNameInRow="UnitName" msprop:Generator_ColumnPropNameInTable="UnitNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Payable" msprop:Generator_UserColumnName="Payable" msprop:Generator_ColumnVarNameInTable="columnPayable" msprop:Generator_ColumnPropNameInRow="Payable" msprop:Generator_ColumnPropNameInTable="PayableColumn" type="xs:boolean" />
              <xs:element name="ProjectName" msprop:Generator_UserColumnName="ProjectName" msprop:Generator_ColumnVarNameInTable="columnProjectName" msprop:Generator_ColumnPropNameInRow="ProjectName" msprop:Generator_ColumnPropNameInTable="ProjectNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProjectNumber" msprop:Generator_UserColumnName="ProjectNumber" msprop:Generator_ColumnVarNameInTable="columnProjectNumber" msprop:Generator_ColumnPropNameInRow="ProjectNumber" msprop:Generator_ColumnPropNameInTable="ProjectNumberColumn" type="xs:int" />
              <xs:element name="ClientName" msprop:Generator_UserColumnName="ClientName" msprop:Generator_ColumnVarNameInTable="columnClientName" msprop:Generator_ColumnPropNameInRow="ClientName" msprop:Generator_ColumnPropNameInTable="ClientNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TaskAssignee" msprop:Generator_UserColumnName="TaskAssignee" msprop:Generator_ColumnVarNameInTable="columnTaskAssignee" msprop:Generator_ColumnPropNameInRow="TaskAssignee" msprop:Generator_ColumnPropNameInTable="TaskAssigneeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BacklogItemNumber" msprop:Generator_UserColumnName="BacklogItemNumber" msprop:Generator_ColumnVarNameInTable="columnBacklogItemNumber" msprop:Generator_ColumnPropNameInRow="BacklogItemNumber" msprop:Generator_ColumnPropNameInTable="BacklogItemNumberColumn" type="xs:short" />
              <xs:element name="TaskType" msprop:Generator_UserColumnName="TaskType" msprop:Generator_ColumnPropNameInRow="TaskType" msprop:Generator_ColumnVarNameInTable="columnTaskType" msprop:Generator_ColumnPropNameInTable="TaskTypeColumn" type="xs:short" />
              <xs:element name="BacklogItemUId" msprop:Generator_UserColumnName="BacklogItemUId" msprop:Generator_ColumnPropNameInRow="BacklogItemUId" msprop:Generator_ColumnVarNameInTable="columnBacklogItemUId" msprop:Generator_ColumnPropNameInTable="BacklogItemUIdColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Finish" msprop:Generator_UserColumnName="Finish" msprop:Generator_ColumnPropNameInRow="Finish" msprop:Generator_ColumnVarNameInTable="columnFinish" msprop:Generator_ColumnPropNameInTable="FinishColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TaskTail" msprop:Generator_UserTableName="TaskTail" msprop:Generator_RowDeletedName="TaskTailRowDeleted" msprop:Generator_RowChangedName="TaskTailRowChanged" msprop:Generator_RowClassName="TaskTailRow" msprop:Generator_RowChangingName="TaskTailRowChanging" msprop:Generator_RowEvArgName="TaskTailRowChangeEvent" msprop:Generator_RowEvHandlerName="TaskTailRowChangeEventHandler" msprop:Generator_TableClassName="TaskTailDataTable" msprop:Generator_TableVarName="tableTaskTail" msprop:Generator_RowDeletingName="TaskTailRowDeleting" msprop:Generator_TablePropName="TaskTail">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TaskTailUId" msprop:Generator_UserColumnName="TaskTailUId" msprop:Generator_ColumnPropNameInRow="TaskTailUId" msprop:Generator_ColumnVarNameInTable="columnTaskTailUId" msprop:Generator_ColumnPropNameInTable="TaskTailUIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArtifactPath" msprop:Generator_UserColumnName="ArtifactPath" msprop:Generator_ColumnPropNameInRow="ArtifactPath" msprop:Generator_ColumnVarNameInTable="columnArtifactPath" msprop:Generator_ColumnPropNameInTable="ArtifactPathColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArtifactRevision" msprop:Generator_UserColumnName="ArtifactRevision" msprop:Generator_ColumnPropNameInRow="ArtifactRevision" msprop:Generator_ColumnVarNameInTable="columnArtifactRevision" msprop:Generator_ColumnPropNameInTable="ArtifactRevisionColumn" type="xs:int" />
              <xs:element name="ArtifactExtension" msprop:Generator_UserColumnName="ArtifactExtension" msprop:Generator_ColumnPropNameInRow="ArtifactExtension" msprop:Generator_ColumnVarNameInTable="columnArtifactExtension" msprop:Generator_ColumnPropNameInTable="ArtifactExtensionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TaskUId" msprop:Generator_UserColumnName="TaskUId" msprop:Generator_ColumnPropNameInRow="TaskUId" msprop:Generator_ColumnVarNameInTable="columnTaskUId" msprop:Generator_ColumnPropNameInTable="TaskUIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CheckInTime" msprop:Generator_UserColumnName="CheckInTime" msprop:Generator_ColumnPropNameInRow="CheckInTime" msprop:Generator_ColumnVarNameInTable="columnCheckInTime" msprop:Generator_ColumnPropNameInTable="CheckInTimeColumn" type="xs:dateTime" />
              <xs:element name="RepositoryUrl" msprop:Generator_UserColumnName="RepositoryUrl" msprop:Generator_ColumnVarNameInTable="columnRepositoryUrl" msprop:Generator_ColumnPropNameInRow="RepositoryUrl" msprop:Generator_ColumnPropNameInTable="RepositoryUrlColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProjectUId" msprop:Generator_UserColumnName="ProjectUId" msprop:Generator_ColumnVarNameInTable="columnProjectUId" msprop:Generator_ColumnPropNameInRow="ProjectUId" msprop:Generator_ColumnPropNameInTable="ProjectUIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ArtifactGroup" msprop:Generator_UserColumnName="ArtifactGroup" msprop:Generator_ColumnVarNameInTable="columnArtifactGroup" msprop:Generator_ColumnPropNameInRow="ArtifactGroup" msprop:Generator_ColumnPropNameInTable="ArtifactGroupColumn" type="xs:string" minOccurs="0" />
              <xs:element name="ActivityName" msprop:Generator_UserColumnName="ActivityName" msprop:Generator_ColumnVarNameInTable="columnActivityName" msprop:Generator_ColumnPropNameInRow="ActivityName" msprop:Generator_ColumnPropNameInTable="ActivityNameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="ActivityOrder" msprop:Generator_UserColumnName="ActivityOrder" msprop:Generator_ColumnVarNameInTable="columnActivityOrder" msprop:Generator_ColumnPropNameInRow="ActivityOrder" msprop:Generator_ColumnPropNameInTable="ActivityOrderColumn" type="xs:int" minOccurs="0" />
              <xs:element name="BacklogItemUId" msprop:Generator_UserColumnName="BacklogItemUId" msprop:Generator_ColumnPropNameInRow="BacklogItemUId" msprop:Generator_ColumnVarNameInTable="columnBacklogItemUId" msprop:Generator_ColumnPropNameInTable="BacklogItemUIdColumn" type="xs:string" minOccurs="0" />
              <xs:element name="ArtifactName" msprop:Generator_UserColumnName="ArtifactName" msprop:Generator_ColumnVarNameInTable="columnArtifactName" msprop:Generator_ColumnPropNameInRow="ArtifactName" msprop:Generator_ColumnPropNameInTable="ArtifactNameColumn" type="xs:string" minOccurs="0" />
              <xs:element name="ArtifactGroupType" msprop:Generator_UserColumnName="ArtifactGroupType" msprop:Generator_ColumnPropNameInRow="ArtifactGroupType" msprop:Generator_ColumnVarNameInTable="columnArtifactGroupType" msprop:Generator_ColumnPropNameInTable="ArtifactGroupTypeColumn" type="xs:string" minOccurs="0" />
              <xs:element name="IsSourceControled" msprop:Generator_UserColumnName="IsSourceControled" msprop:Generator_ColumnPropNameInRow="IsSourceControled" msprop:Generator_ColumnVarNameInTable="columnIsSourceControled" msprop:Generator_ColumnPropNameInTable="IsSourceControledColumn" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TaskTailImpactedItem" msprop:Generator_UserTableName="TaskTailImpactedItem" msprop:Generator_RowDeletedName="TaskTailImpactedItemRowDeleted" msprop:Generator_RowChangedName="TaskTailImpactedItemRowChanged" msprop:Generator_RowClassName="TaskTailImpactedItemRow" msprop:Generator_RowChangingName="TaskTailImpactedItemRowChanging" msprop:Generator_RowEvArgName="TaskTailImpactedItemRowChangeEvent" msprop:Generator_RowEvHandlerName="TaskTailImpactedItemRowChangeEventHandler" msprop:Generator_TableClassName="TaskTailImpactedItemDataTable" msprop:Generator_TableVarName="tableTaskTailImpactedItem" msprop:Generator_RowDeletingName="TaskTailImpactedItemRowDeleting" msprop:Generator_TablePropName="TaskTailImpactedItem">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SourceBacklogItemUId" msprop:Generator_UserColumnName="SourceBacklogItemUId" msprop:Generator_ColumnPropNameInRow="SourceBacklogItemUId" msprop:Generator_ColumnVarNameInTable="columnSourceBacklogItemUId" msprop:Generator_ColumnPropNameInTable="SourceBacklogItemUIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProjectUId" msprop:Generator_UserColumnName="ProjectUId" msprop:Generator_ColumnPropNameInRow="ProjectUId" msprop:Generator_ColumnVarNameInTable="columnProjectUId" msprop:Generator_ColumnPropNameInTable="ProjectUIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProjectName" msprop:Generator_UserColumnName="ProjectName" msprop:Generator_ColumnPropNameInRow="ProjectName" msprop:Generator_ColumnVarNameInTable="columnProjectName" msprop:Generator_ColumnPropNameInTable="ProjectNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProjectNumber" msprop:Generator_UserColumnName="ProjectNumber" msprop:Generator_ColumnPropNameInRow="ProjectNumber" msprop:Generator_ColumnVarNameInTable="columnProjectNumber" msprop:Generator_ColumnPropNameInTable="ProjectNumberColumn" type="xs:int" />
              <xs:element name="BacklogItemUId" msprop:Generator_UserColumnName="BacklogItemUId" msprop:Generator_ColumnPropNameInRow="BacklogItemUId" msprop:Generator_ColumnVarNameInTable="columnBacklogItemUId" msprop:Generator_ColumnPropNameInTable="BacklogItemUIdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInTable="TitleColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BacklogItemNumber" msprop:Generator_UserColumnName="BacklogItemNumber" msprop:Generator_ColumnPropNameInRow="BacklogItemNumber" msprop:Generator_ColumnVarNameInTable="columnBacklogItemNumber" msprop:Generator_ColumnPropNameInTable="BacklogItemNumberColumn" type="xs:short" />
              <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="AverageHoursBySizeItemType" msprop:Generator_UserTableName="AverageHoursBySizeItemType" msprop:Generator_RowDeletedName="AverageHoursBySizeItemTypeRowDeleted" msprop:Generator_RowChangedName="AverageHoursBySizeItemTypeRowChanged" msprop:Generator_RowClassName="AverageHoursBySizeItemTypeRow" msprop:Generator_RowChangingName="AverageHoursBySizeItemTypeRowChanging" msprop:Generator_RowEvArgName="AverageHoursBySizeItemTypeRowChangeEvent" msprop:Generator_RowEvHandlerName="AverageHoursBySizeItemTypeRowChangeEventHandler" msprop:Generator_TableClassName="AverageHoursBySizeItemTypeDataTable" msprop:Generator_TableVarName="tableAverageHoursBySizeItemType" msprop:Generator_RowDeletingName="AverageHoursBySizeItemTypeRowDeleting" msprop:Generator_TablePropName="AverageHoursBySizeItemType">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SizeItemType" msprop:Generator_UserColumnName="SizeItemType" msprop:Generator_ColumnVarNameInTable="columnSizeItemType" msprop:Generator_ColumnPropNameInRow="SizeItemType" msprop:Generator_ColumnPropNameInTable="SizeItemTypeColumn" type="xs:short" />
              <xs:element name="UnitName" msprop:Generator_UserColumnName="UnitName" msprop:Generator_ColumnVarNameInTable="columnUnitName" msprop:Generator_ColumnPropNameInRow="UnitName" msprop:Generator_ColumnPropNameInTable="UnitNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Hours" msprop:Generator_UserColumnName="Hours" msprop:Generator_ColumnVarNameInTable="columnHours" msprop:Generator_ColumnPropNameInRow="Hours" msprop:Generator_ColumnPropNameInTable="HoursColumn" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Task" />
      <xs:field xpath="mstns:TaskUId" />
    </xs:unique>
    <xs:unique name="Constraint2">
      <xs:selector xpath=".//mstns:Task" />
      <xs:field xpath="mstns:TaskId" />
    </xs:unique>
    <xs:unique name="TaskResume_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TaskResume" />
      <xs:field xpath="mstns:TaskUId" />
    </xs:unique>
    <xs:unique name="TaskTail_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TaskTail" />
      <xs:field xpath="mstns:TaskTailUId" />
    </xs:unique>
    <xs:unique name="AverageHoursBySizeItemType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:AverageHoursBySizeItemType" />
      <xs:field xpath="mstns:SizeItemType" />
      <xs:field xpath="mstns:UnitName" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_TaskTail_TaskTail" msdata:parent="Task" msdata:child="TaskTail" msdata:parentkey="TaskUId" msdata:childkey="TaskUId" msprop:Generator_UserRelationName="FK_TaskTail_TaskTail" msprop:Generator_RelationVarName="relationFK_TaskTail_TaskTail" msprop:Generator_UserChildTable="TaskTail" msprop:Generator_UserParentTable="Task" msprop:Generator_ParentPropName="TaskRow" msprop:Generator_ChildPropName="GetTaskTailRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>